package com.ruoyi.biz.letter.mapper;

import com.ruoyi.biz.letter.domain.BizRecordLetter;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.biz.report.letter.vo.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 督办事项登记Mapper接口
 *
 * @author Fei.Cong
 * @date 2024-07-11
 */
@Mapper
public interface BizRecordLetterMapper extends BaseMapper<BizRecordLetter> {

    IPage<BizRecordLetter> selectPageList(IPage<BizRecordLetter> page, @Param("entity") BizRecordLetter bizRecordLetter);

    List<ReportCityCategoryResp> selectReportGroupCityAndCategory(@Param("entity") CategoryReportReq reportReq);

    List<ReportYearCityResp> selectReportGroupMonthAndOwnerArea(@Param("entity") CategoryReportReq reportReq);

    List<ReportYearCategoryResp> selectReportGroupMonthAndCategory(@Param("entity") CategoryReportReq reportReq);

    List<ReportYearCategoryResp> selectReportGroupMonthAndSource();

    List<CategoryCount> selectReportGroupCategory(@Param("currentMonth") String currentMonth, @Param("source") Integer source);

}
